Can't find Edit Filter/Sort on Records due to replaced by Filter command.
Cause:
The 'Edit Filter/Sort' command has been replaced by the 'Filter' command.
Solution:
To filter records in Access 7.0, select the 'Records' menu, select 'Filter', and select the type of filter.
1) Select the 'Records' menu and select 'Filter'. (A submenu appears.)
2) Select the filter method from the 'Filter' submenu.
3) (Special Case) If 'Filter By Form' is selected in step 2), do the following in the 'Filter By Form' window:
a) Select the field in which to specify the criteria for records to be included in the filtered set.
b) Select the value for the criteria from the drop-down list in the selected field.
Select value
NOTE: If values are specified in more than one field, the filter returns a record ONLY if it contains the same values in each field.
c) (Optional) To specify alternative values, click the 'Or' tab.
NOTE: The filter returns records if they have all values specified in the 'Look For' tab OR all values specified in the first 'Or' tab OR the second 'Or' tab, etc.
d) Select the 'Filter' menu and select 'Apply Filter/Sort'.
4) (Special Case) If 'Filter By Selection' is selected in step 2), select the records to be filtered.
5) (Special Case) If 'Advanced Filter/Sort...' is selected in step 2), do the following in the filter design window that opens:
a) Select the field to sort on from the drop-down list box in the first cell in the 'Field' row.
b) Select the sort method from the drop-down list box in the first cell in the 'Sort' row.
Select sort method
c) Type any necessary criteria in the 'Criteria' cells.
d) Repeat steps 5)a) through 5)c), moving to the next column, for each sort to define.
